package com.xhkj.mapper.my;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.xhkj.mapper.CommonMapper;
import com.xhkj.model.City;
public interface CityMapper extends CommonMapper<City>{
	@Select("select distinct sheng from city")
	List<City> getSheng();

	@Select("select * from city where sheng = #{sheng} and shi = quxian")
	List<City> getShi(String sheng);
	
	@Select("select * from city where sheng = #{sheng} and shi = #{shi} and shi <> quxian")
	List<City> getQuxian(String sheng, String shi);
}